/*
 Navicat Premium Data Transfer

 Source Server         : alicloud-47.98.132.236
 Source Server Type    : MySQL
 Source Server Version : 50729
 Source Host           : 47.98.132.236:3306
 Source Schema         : ptl-demo

 Target Server Type    : MySQL
 Target Server Version : 50729
 File Encoding         : 65001

 Date: 05/02/2020 17:39:31
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for hibernate_sequence
-- ----------------------------
DROP TABLE IF EXISTS `hibernate_sequence`;
CREATE TABLE `hibernate_sequence` (
  `next_val` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of hibernate_sequence
-- ----------------------------
BEGIN;
INSERT INTO `hibernate_sequence` VALUES (1);
COMMIT;

-- ----------------------------
-- Table structure for ptl_action_module
-- ----------------------------
DROP TABLE IF EXISTS `ptl_action_module`;
CREATE TABLE `ptl_action_module` (
  `id` bigint(20) NOT NULL,
  `create_datetime` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `am_code` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `am_desc` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `am_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `am_type` int(11) DEFAULT NULL,
  `call_class` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of ptl_action_module
-- ----------------------------
BEGIN;
INSERT INTO `ptl_action_module` VALUES (1, NULL, 'action1Module', '123', '调用module组件', 20, 'action1Module');
INSERT INTO `ptl_action_module` VALUES (2, NULL, 'action2Module', '123', '调用module组件', 20, 'action2Module');
INSERT INTO `ptl_action_module` VALUES (3, NULL, 'out1Module', '123', '离开module组件', 20, 'out1Module');
INSERT INTO `ptl_action_module` VALUES (4, NULL, 'out2Module', '123', '离开module组件', 20, 'out2Module');
INSERT INTO `ptl_action_module` VALUES (5, NULL, 'tagOffValidationModule', '123', '灭灯校验', 10, 'tagOffValidationModule');
INSERT INTO `ptl_action_module` VALUES (6, NULL, 'finalizerValidationModule', '123', '完成器校验', 10, 'finalizerValidationModule');
INSERT INTO `ptl_action_module` VALUES (7, NULL, 'taskDetailCompleteModule', '123', '任务明细完成', 10, 'taskDetailCompleteModule');
INSERT INTO `ptl_action_module` VALUES (8, NULL, 'checkTaskDetailModule', '123', '检查任务明细完成', 10, 'checkTaskDetailModule');
INSERT INTO `ptl_action_module` VALUES (9, NULL, 'lightFinalizerModule', '123', '点亮完成器', 10, 'lightFinalizerModule');
INSERT INTO `ptl_action_module` VALUES (10, NULL, 'sectionTaskCompleteModule', '123', '区段任务完成', 10, 'sectionTaskCompleteModule');
INSERT INTO `ptl_action_module` VALUES (11, NULL, 'printTagModule', '123', '打印标签组件', 10, 'printTagModule');
COMMIT;

-- ----------------------------
-- Table structure for ptl_action_module_group
-- ----------------------------
DROP TABLE IF EXISTS `ptl_action_module_group`;
CREATE TABLE `ptl_action_module_group` (
  `id` bigint(20) NOT NULL,
  `create_datetime` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `am_code` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `amg_id` bigint(20) DEFAULT NULL,
  `seq` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of ptl_action_module_group
-- ----------------------------
BEGIN;
INSERT INTO `ptl_action_module_group` VALUES (1, NULL, 'action1Module', 10, 1);
INSERT INTO `ptl_action_module_group` VALUES (2, NULL, 'action2Module', 10, 2);
INSERT INTO `ptl_action_module_group` VALUES (3, NULL, 'out1Module', 30, 1);
INSERT INTO `ptl_action_module_group` VALUES (4, NULL, 'out2Module', 30, 2);
INSERT INTO `ptl_action_module_group` VALUES (5, NULL, 'tagOffValidationModule', 20, 1);
INSERT INTO `ptl_action_module_group` VALUES (6, NULL, 'finalizerValidationModule', 21, 1);
INSERT INTO `ptl_action_module_group` VALUES (7, NULL, 'taskDetailCompleteModule', 22, 1);
INSERT INTO `ptl_action_module_group` VALUES (8, NULL, 'checkTaskDetailModule', 23, 1);
INSERT INTO `ptl_action_module_group` VALUES (9, NULL, 'lightFinalizerModule', 24, 1);
INSERT INTO `ptl_action_module_group` VALUES (10, NULL, 'sectionTaskCompleteModule', 25, 1);
INSERT INTO `ptl_action_module_group` VALUES (11, NULL, 'printTagModule', 26, 1);
COMMIT;

-- ----------------------------
-- Table structure for ptl_action_route
-- ----------------------------
DROP TABLE IF EXISTS `ptl_action_route`;
CREATE TABLE `ptl_action_route` (
  `id` bigint(20) NOT NULL,
  `create_datetime` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `route_code` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `route_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of ptl_action_route
-- ----------------------------
BEGIN;
INSERT INTO `ptl_action_route` VALUES (1, '2020-02-01 11:11:11', 'route01', '1#route');
COMMIT;

-- ----------------------------
-- Table structure for ptl_area
-- ----------------------------
DROP TABLE IF EXISTS `ptl_area`;
CREATE TABLE `ptl_area` (
  `id` bigint(20) NOT NULL,
  `create_datetime` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `area_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `area_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of ptl_area
-- ----------------------------
BEGIN;
INSERT INTO `ptl_area` VALUES (1, NULL, 'area01', 'area01');
COMMIT;

-- ----------------------------
-- Table structure for ptl_area_route
-- ----------------------------
DROP TABLE IF EXISTS `ptl_area_route`;
CREATE TABLE `ptl_area_route` (
  `id` bigint(20) NOT NULL,
  `create_datetime` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `area_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `route_code` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of ptl_area_route
-- ----------------------------
BEGIN;
INSERT INTO `ptl_area_route` VALUES (1, '2020-02-01 11:11:11', 'area01', 'route01');
COMMIT;

-- ----------------------------
-- Table structure for ptl_area_section_task
-- ----------------------------
DROP TABLE IF EXISTS `ptl_area_section_task`;
CREATE TABLE `ptl_area_section_task` (
  `id` bigint(20) NOT NULL,
  `create_datetime` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `area_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `area_task_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `cust_flag_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `detail_seq` int(11) DEFAULT NULL,
  `part_location` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `part_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `part_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `prod_cfg_code` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `prod_cfg_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `section_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `section_task_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `sn` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `vin_code` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Table structure for ptl_area_section_task_detail
-- ----------------------------
DROP TABLE IF EXISTS `ptl_area_section_task_detail`;
CREATE TABLE `ptl_area_section_task_detail` (
  `id` bigint(20) NOT NULL,
  `create_datetime` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `area_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `bin_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `control_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `display_content` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `is_buzzing` int(11) DEFAULT NULL,
  `light_color` int(11) DEFAULT NULL,
  `light_mode` int(11) DEFAULT NULL,
  `music_type` int(11) DEFAULT NULL,
  `part_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `section_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `section_task_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `tag_no` int(11) DEFAULT NULL,
  `tag_type` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of ptl_area_section_task_detail
-- ----------------------------
BEGIN;
INSERT INTO `ptl_area_section_task_detail` VALUES (1, '2020-01-21 11:11:11', 'a1', 'b1', 'c1', 'nihao', 1, 1, 1, 1, '123X', 1, 's1', 'st1', 0, 1, 0);
INSERT INTO `ptl_area_section_task_detail` VALUES (2, '2020-01-21 11:11:11', 'a1', 'b1', 'c1', 'nihao', 1, 1, 1, 1, '123X', 1, 's1', 'st1', 0, 2, 0);
INSERT INTO `ptl_area_section_task_detail` VALUES (3, '2020-01-21 11:11:11', 'a1', 'b1', 'c1', 'nihao', 1, 1, 1, 1, '123X', 1, 's1', 'st1', 0, 3, 0);
INSERT INTO `ptl_area_section_task_detail` VALUES (4, '2020-01-21 11:11:11', 'a1', 'b1', 'c1', 'nihao', 1, 1, 1, 1, '123X', 1, 's1', 'st1', 0, 4, 0);
COMMIT;

-- ----------------------------
-- Table structure for ptl_area_task
-- ----------------------------
DROP TABLE IF EXISTS `ptl_area_task`;
CREATE TABLE `ptl_area_task` (
  `id` bigint(20) NOT NULL,
  `create_datetime` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `area_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `area_task_no` bigint(20) DEFAULT NULL,
  `cust_flag_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `detail_seq` int(11) DEFAULT NULL,
  `part_location` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `part_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `part_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `prod_cfg_code` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `prod_cfg_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `seq` int(11) DEFAULT NULL,
  `sn` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `task_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `task_type` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `vin_code` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Table structure for ptl_area_task_seq
-- ----------------------------
DROP TABLE IF EXISTS `ptl_area_task_seq`;
CREATE TABLE `ptl_area_task_seq` (
  `id` bigint(20) NOT NULL,
  `create_datetime` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `area_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `detail_seq` int(11) DEFAULT NULL,
  `seq` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Table structure for ptl_bom
-- ----------------------------
DROP TABLE IF EXISTS `ptl_bom`;
CREATE TABLE `ptl_bom` (
  `id` bigint(20) NOT NULL,
  `create_datetime` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `bom_number` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `bom_version` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `eff_end_time` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `eff_start_time` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `item_part_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `item_part_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `item_qty` int(11) DEFAULT NULL,
  `item_unit` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `part_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `part_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `unit` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Table structure for ptl_control
-- ----------------------------
DROP TABLE IF EXISTS `ptl_control`;
CREATE TABLE `ptl_control` (
  `id` bigint(20) NOT NULL,
  `create_datetime` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `area_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `control_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `control_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `control_type` int(11) DEFAULT NULL,
  `frequency` int(11) DEFAULT NULL,
  `ip` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `port` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of ptl_control
-- ----------------------------
BEGIN;
INSERT INTO `ptl_control` VALUES (1, '2020-01-21 11:11:11', 'a1', 'c1name', '1', 1, 1, '1', '1', 0);
COMMIT;

-- ----------------------------
-- Table structure for ptl_main_task
-- ----------------------------
DROP TABLE IF EXISTS `ptl_main_task`;
CREATE TABLE `ptl_main_task` (
  `id` bigint(20) NOT NULL,
  `create_datetime` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `area_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `cust_flag_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `detail_seq` int(11) DEFAULT NULL,
  `part_location` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `part_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `part_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `prod_cfg_code` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `prod_cfg_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `seq` int(11) DEFAULT NULL,
  `sn` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `task_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `task_src` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `task_type` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `vin_code` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Table structure for ptl_method
-- ----------------------------
DROP TABLE IF EXISTS `ptl_method`;
CREATE TABLE `ptl_method` (
  `id` bigint(20) NOT NULL,
  `create_datetime` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `call_class` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `method_code` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `method_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `method_type` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Table structure for ptl_method_group
-- ----------------------------
DROP TABLE IF EXISTS `ptl_method_group`;
CREATE TABLE `ptl_method_group` (
  `id` bigint(20) NOT NULL,
  `create_datetime` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `group_code` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `group_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `method_code` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `seq` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Table structure for ptl_route_status
-- ----------------------------
DROP TABLE IF EXISTS `ptl_route_status`;
CREATE TABLE `ptl_route_status` (
  `id` bigint(20) NOT NULL,
  `create_datetime` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `action_amg_id` int(11) DEFAULT NULL,
  `in_amg_id` int(11) DEFAULT NULL,
  `next_status` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `out_amg_id` int(11) DEFAULT NULL,
  `route_code` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `status_code` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `status_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `trigger_event` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `trigger_type` int(11) DEFAULT NULL,
  `trigger_where` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `seq` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of ptl_route_status
-- ----------------------------
BEGIN;
INSERT INTO `ptl_route_status` VALUES (1, NULL, 20, 10, 'OFF_TAG_CHECK', 30, 'route01', 'START', '开始', 'OFF_TAG_EVENT', 10, 'TagSignalBo:::context.msg==\"off\"', 1);
INSERT INTO `ptl_route_status` VALUES (2, NULL, 21, 10, 'FINALIZER_CHECK', 30, 'route01', 'OFF_TAG_CHECK', '有效灭灯校验', 'SUCCESS', 10, NULL, 2);
INSERT INTO `ptl_route_status` VALUES (3, NULL, NULL, 10, 'START', 30, 'route01', 'OFF_TAG_CHECK', '有效灭灯校验', 'FAILURE', 10, NULL, 2);
INSERT INTO `ptl_route_status` VALUES (4, NULL, 25, 10, 'SECTION_TASK_COMPLETE', 30, 'route01', 'FINALIZER_CHECK', '完成器校验', 'SUCCESS', 10, NULL, 3);
INSERT INTO `ptl_route_status` VALUES (5, NULL, 22, 10, 'TASK_DETAIL_COMPLETE', 30, 'route01', 'FINALIZER_CHECK', '完成器校验', 'FAILURE', 10, NULL, 3);
INSERT INTO `ptl_route_status` VALUES (6, NULL, 23, 10, 'CHECK_DETAIL', 30, 'route01', 'TASK_DETAIL_COMPLETE', '任务明细完成', 'SUCCESS', 10, NULL, 4);
INSERT INTO `ptl_route_status` VALUES (7, NULL, 24, 10, 'LIGHT_FINALIZER', 30, 'route01', 'CHECK_DETAIL', '任务明细是否完成', 'SUCCESS', 10, NULL, 5);
INSERT INTO `ptl_route_status` VALUES (8, NULL, NULL, 10, 'START', 30, 'route01', 'LIGHT_FINALIZER', '任务明细是否完成', 'SUCCESS', 10, NULL, 5);
INSERT INTO `ptl_route_status` VALUES (9, NULL, NULL, 10, 'START', 30, 'route01', 'CHECK_DETAIL', '任务明细是否完成', 'FAILURE', 10, NULL, 5);
INSERT INTO `ptl_route_status` VALUES (10, NULL, 26, 10, 'PRINT_TAG', 30, 'route01', 'SECTION_TASK_COMPLETE', '任务明细是否完成', 'SUCCESS', 10, NULL, 6);
INSERT INTO `ptl_route_status` VALUES (11, NULL, NULL, 10, 'START', 30, 'route01', 'PRINT_TAG', '任务明细是否完成', 'SUCCESS', 10, NULL, 7);
COMMIT;

-- ----------------------------
-- Table structure for ptl_section
-- ----------------------------
DROP TABLE IF EXISTS `ptl_section`;
CREATE TABLE `ptl_section` (
  `id` bigint(20) NOT NULL,
  `create_datetime` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `area_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `section_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `section_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `section_seq` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Table structure for ptl_status_cfg
-- ----------------------------
DROP TABLE IF EXISTS `ptl_status_cfg`;
CREATE TABLE `ptl_status_cfg` (
  `id` bigint(20) NOT NULL,
  `create_datetime` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `object_code` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `status_value` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Table structure for ptl_status_event
-- ----------------------------
DROP TABLE IF EXISTS `ptl_status_event`;
CREATE TABLE `ptl_status_event` (
  `id` bigint(20) NOT NULL,
  `create_datetime` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `action_event_code` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `desc_status` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `in_event_code` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `model_code` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `object_code` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `out_event_code` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `src_status` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Table structure for ptl_status_object
-- ----------------------------
DROP TABLE IF EXISTS `ptl_status_object`;
CREATE TABLE `ptl_status_object` (
  `id` bigint(20) NOT NULL,
  `create_datetime` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `object_code` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `object_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Table structure for ptl_tag
-- ----------------------------
DROP TABLE IF EXISTS `ptl_tag`;
CREATE TABLE `ptl_tag` (
  `id` bigint(20) NOT NULL,
  `create_datetime` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `area_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `bin_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `control_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `display_content` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `errir_cunt` int(11) DEFAULT NULL,
  `is_buzzing` int(11) DEFAULT NULL,
  `light_color` int(11) DEFAULT NULL,
  `light_mode` int(11) DEFAULT NULL,
  `light_status` int(11) DEFAULT NULL,
  `music_type` int(11) DEFAULT NULL,
  `part_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `sertion_no` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `tag_no` int(11) DEFAULT NULL,
  `tag_status` int(11) DEFAULT NULL,
  `tag_type` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of ptl_tag
-- ----------------------------
BEGIN;
INSERT INTO `ptl_tag` VALUES (1, '2020-01-21 11:11:11', 'a1', 'b1', 'c1', 'nihao', 1, 1, 0, 1, 0, 1, '123X', '1', 1, 0, 1);
INSERT INTO `ptl_tag` VALUES (2, '2020-01-21 11:11:11', 'a1', 'b1', 'c1', 'nihao', 1, 1, 0, 1, 0, 1, '123X', '1', 2, 0, 1);
INSERT INTO `ptl_tag` VALUES (3, '2020-01-21 11:11:11', 'a1', 'b1', 'c1', 'nihao', 1, 1, 0, 1, 0, 1, '123X', '1', 3, 0, 1);
INSERT INTO `ptl_tag` VALUES (4, '2020-01-21 11:11:11', 'a1', 'b1', 'c1', 'nihao', 1, 1, 0, 1, 0, 1, '123X', '1', 4, 0, 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
